<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_attribute`;");
E_C("CREATE TABLE `ecs_attribute` (
  `attr_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `attr_name` varchar(60) NOT NULL DEFAULT '',
  `attr_input_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `attr_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `attr_values` text NOT NULL,
  `attr_index` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `is_linked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `attr_group` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`attr_id`),
  KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_attribute` values('1','1','种类','1','0','翡翠类\r\n和田玉\r\n独山玉\r\n蓝田玉\r\n岫岩玉\r\n巴山玉\r\n宝石类','0','0','0','0');");
E_D("replace into `ecs_attribute` values('2','1','琢形','1','0','耳饰\r\n项链\r\n手镯\r\n戒指\r\n吊坠\r\n手链\r\n其他','1','0','0','0');");
E_D("replace into `ecs_attribute` values('3','1','图案','1','0','天使\r\n龙/凤\r\n生肖\r\n貔貅\r\n观音\r\n佛\r\n其他','1','0','0','0');");
E_D("replace into `ecs_attribute` values('4','1','年代','1','0','老玉\r\n新玉','1','0','0','0');");
E_D("replace into `ecs_attribute` values('5','1','颜色','1','0','白玉\r\n墨玉\r\n碧玉','1','0','0','0');");
E_D("replace into `ecs_attribute` values('6','2','种地类型','0','0','','0','1','0','0');");
E_D("replace into `ecs_attribute` values('7','2',' 图案/形状','0','0','','0','2','0','0');");
E_D("replace into `ecs_attribute` values('8','2','售后服务','0','0','','0','3','0','0');");
E_D("replace into `ecs_attribute` values('9','2','证书','0','0','','0','4','0','0');");
E_D("replace into `ecs_attribute` values('10','2','证书认证标识','0','0','','0','5','0','0');");
E_D("replace into `ecs_attribute` values('11','2','镶嵌材质','0','0','','0','6','0','0');");
E_D("replace into `ecs_attribute` values('12','2','品牌','0','0','','0','7','0','0');");
E_D("replace into `ecs_attribute` values('13','2','货号','0','0','','0','8','0','0');");
E_D("replace into `ecs_attribute` values('14','2','价格区间','0','0','','0','9','0','0');");
E_D("replace into `ecs_attribute` values('15','2','款式','0','0','','0','10','0','0');");

require("../../inc/footer.php");
?>